package com.bookmngsys.dao;

import com.bookmngsys.entity.BookInfo;
import com.bookmngsys.entity.BookLocation;
import com.bookmngsys.entity.Category;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;


/**
 * @author han
 */
public interface BookLocationDao extends JpaRepository<BookLocation, String> {


    @Query(value = "select * from book_location where rack_number = :rackNumber", nativeQuery = true)
    BookLocation findBookLocationByBookId(String rackNumber);


}